Creating a subscriptions database

The document event subscription feature requires an existing external database in which to store subscription information for each user. By default, Meridian Enterprise does not create this database automatically. If subscriptions will be allowed in the vault, a database must be created by a database administrator. The Meridian application server and the database must meet the requirements described in Recommended server specifications. Scripts for SQL Server and Oracle are installed by the Meridian Enterprise setup program for your convenience that will create the database and the necessary schema. The scripts must be executed by a user with sufficient rights to perform the actions in the scripts.

Warning    If the subscription database already exists, the scripts will delete it first and then recreate it.

To create a subscriptions database in SQL Server:

1. Copy the following script file from the Meridian application server to the SQL Server host computer:

C:\Program Files\BC-Meridian\Program\BC Notification\BCNotesDB.sql

2. On the SQL Server host computer, navigate to the folder where you copied the file in step 1.
3. Run the script using the sqlcmd command-line program and one of the following examples:

Note

• We recommend using the database name <VaultName>Subscriptions.

• If the database server is running SQL Server Express, SQL Server Small Business, or another edition that creates a default named instance when the software is installed, specify the name of the database server and the SQL Server instance name together, for example, <ServerName>\SQLEXPRESS or <ServerName>\MSSMLBIZ.

sqlcmd -S <ServerName> -E -i BCNotesDB.sql -v DatabaseName = "<SubscriptionsDatabaseName>"

Or

sqlcmd -S <ServerName> -U <UserName> -P <Password> -i BCNotesDB.sql -v DatabaseName = "<SubscriptionsDatabaseName>"

To create a subscriptions database in Oracle:

1. Copy the following file on the Meridian Enterprise application server to the Oracle host computer:

C:\Program Files\BC-Meridian\Program\BC Notification\ORACreateTablesNt.sql

2. On the Oracle host computer, navigate to the folder where you copied the files in step 1.
3. Open SQL *Plus.
4. Run the following command:

@ORACreateTablesNt.sql